VLOOKUP formula won't work

**edrachel** · 01-19-2005, 11:33 AM

=VLOOKUP(D12&J6,PhysDmg!A282:L302,2,FALSE)
OK, I give up. I am trying to get a cell to look at two items on the Physical Damage(sheet 1) page and pull from the PhysDmg (sheet 2)page. What am I doing wrong? Example: The sheet two page named PhysDmg shows in column A 11000 or 21000 or 31000. Column B would have the number I want returned. On sheet one named Physical Damage cell d12 would have a number like 1 or 2 or 3. Cell J6 would have the number 1000. All I am getting with my formula is N/A. I have used this same formula on other worksheets and it has worked fine. Please help. Thanks.

**Domenic** · 01-19-2005, 11:56 AM

When you concatenate D12 and J6, it returns a text string. So what you have is a text value as your lookup value trying to match against numerical values. You can coerce the text string into a numerical value...

=VLOOKUP(--(D12&J6),PhysDmg!A282:L302,2,FALSE)

Hope this helps!

Originally Posted by edrachel

=VLOOKUP(D12&J6,PhysDmg!A282:L302,2,FALSE)
OK, I give up. I am trying to get a cell to look at two items on the Physical Damage(sheet 1) page and pull from the PhysDmg (sheet 2)page. What am I doing wrong? Example: The sheet two page named PhysDmg shows in column A 11000 or 21000 or 31000. Column B would have the number I want returned. On sheet one named Physical Damage cell d12 would have a number like 1 or 2 or 3. Cell J6 would have the number 1000. All I am getting with my formula is N/A. I have used this same formula on other worksheets and it has worked fine. Please help. Thanks.