I have created a jet report for inventory by location.
I would like to link to this sheet from another spreadsheet. I am doing a vlookup and I do not get any results. It is a very simple formula so I am sure it is ok.
=vlookup( my cellto go find, the range in the jet report,5,false)
Date
Votes
1 comment
-
Jet Reports Historic Posts This is likely more of an Excel issue than a Jet Reports issue. I recall having a similar issue myself (but not involving Jet Reports). Here's what I found in the Mr.Excel forums on this topic:
You can do it if the other workbook is open or closed, but it's easier if it's open.
Start your Vlookup, then ALT+W to locate & activate your other workbook, select your Source Table range & Column count, then enter.
You should get something like this:
=VLOOKUP(A1,'[The Other Workbook.xls]Sheet Name'!$C$12,1,FALSE)
Note that when doing this, Excel will automatically make the Source Table range absolute.
The poster then commented that the issue went deeper, returning an error value due to incompatible cell values. This is most likely what you are facing. In that case, you'll probably need a formula more like this:
=VLOOKUP(text(A1,0),'[The Other Workbook.xls]Sheet Name'!$C$12,1,FALSE)
this converts your lookup value to Text, which is likely what you are getting as output from the Jet Report.
If this helps, all credit goes to the helpful folks over at Mr.Excel :)
Please sign in to leave a comment.