VLookup

[brandon16]

Hi,

I have 2 excel workbook

Data-MI
Joblist

I need a lookup from cell J1 to say If

Cell a2 (Data-MI) = Cells A:A (joblist) the'project' else 'null'

If anyone can help please?

 

[brandon16]

Sorry it should read

If job (column A data-Mi) = Job (column A joblist) then return values in column E (joblist) else return blank

 

[Johnny C]

Not a VLOOKUP, a different way of doing it (I've never used a VLOOKUP)
On row 2 put this and copy down
=IFERROR(OFFSET(Job!E$1,MATCH(data-MI!A2,Job!A:A,0)-1,0),0),"")
or
=IFERROR(OFFSET(Job!A$1,MATCH(data-MI!A2,Job!A:A,0)-1,0),4),"")
is the same thing

 

[hotabae]

I'm not sure I understand what you are trying to do, but here is what I came up with.

If both workbooks are open at the same time, you could put this formula in J2 of "Data-MI":

=IFNA(VLOOKUP(A2,[joblist.xlsx]Sheet1!$A:$E,5),"")

If joblist is closed, you will need to put the path in place of the bracketed file name (I used desktop below):

=IFNA(VLOOKUP(A2,'C:\Users\[B]UserName[/B]\Desktop\[joblist.xlsx]Sheet1'!$A:$E,5),"")

The above solutions are assuming that you are looking for the A2 Value anywhere within joblist's 'A' Column. It does not have to be in A2 of joblist.