CODEWITHSUNDEEP
excelexcel-formulavlookupworksheet-function
Jain
Jain

Reputation: 999

V/HLOOKUP across spreadsheets returns #VALUE! error

I am trying to pull data from one spreadsheet to another. One of the spreadsheets pulls out the data from MS Access. All my data was updated and when I dragged the rows to update current data it shows #VALUE! in every cell which I tried to update.

=VLOOKUP($A1,'From Access'!$A$101:$BBB$113,HLOOKUP(Presentation!AFI$2,'From Access'!$A$101:$BBB$113,13,FALSE),FALSE)/1000000

The second last step in formula evaluation comes to: 

=VLOOKUP("XYZ Industries",'From Access'!$A$101:$BBB$113,0,FALSE)/1000000

while the previously updated cells have some value instead of zero like 800, 805 etc.

=VLOOKUP("XYZ Industries",'From Access'!$A$101:$BBB$113,**somevalue**,FALSE)/1000000

What can be the issue?

Upvotes: 0

Views: 232

Answers (1)

pnuts
pnuts

Reputation: 59475

The OP’s formula was properly constructed but being fed a parameter for col_index-num in a VLOOKUP from a formula that returned 0:

If col_index_num is:

• Less than 1, VLOOKUP returns the #VALUE! error value.

Upvotes: 0

Related Questions