Please review the enclosed EXCEL file:
The formula I have entered{ VLOOKUP(B2,Candidates!$A$2:$B$606,2,FALSE)} on the column I of the Sheet (SUBJECT1) returns AN ERROR MESSAGE (#N/A).
How do I solve the problem???

Solved by V. H. in 30 mins

Hi there,
I am trying to do a vlookup using addresses, to get the job ID numbers attached to job addresses.I have one lot of data with addresses and missing job numbers and another with addresses and job numbers. How do I replace the missing job numbers with the correct addresses.

Solved by G. L. in 27 mins

how do I use vlookup?

Solved by D. J. in 20 mins

How do I do vlookup?

Solved by A. Q. in 17 mins

How do I do this: "Use a VLOOKUP formula to calculate the dollar value in sales.

Solved by X. H. in 24 mins

I'm looking to create a form where drop-downs change depending on what was chosen in the previous cell. I'd like to be able to somehow do a VLOOKUP in a Data Validation, if possible.

Solved by A. F. in 23 mins

How do I do a vlookup in a google spreadsheet?

Solved by S. C. in 24 mins

How do I do a vlookup in a google spreadsheet? I want to figure out who's a VIP customer for customers listed in sheet one. Sheet contains their status

Solved by X. U. in 23 mins

I need help with a VLOOKUP formula. How do create a formula.

Solved by K. A. in 12 mins

I have no clue how to use vlookup

Solved by V. W. in 24 mins