Forum Discussion
Solved
Help with formula to pull inventory #s from one excel sheet and input into another
Hi there, Could I get some formula help please? I have 1 inventory sheet that I need to update with the #s from another sheet. What I would like to accomplish is: If an item # in WORKSHEE...
=VLOOKUP(B2,'[WORKSHEET 2.xlsx]Sheet1'!$B$2:$F$30,5,FALSE)This formula returns the intended result if the ItemNo in column B in WORKSHEET 2 are formatted as in WORKSHEET 1.
=VLOOKUP("*" & TEXT(B2,"@") & "*",'[WORKSHEET 2.xlsx]Sheet1'!$B$2:$F$30 & "",5,FALSE)
Hmm I can't seem to get this to work. I'm getting #NA for all now using this formula. Thoughts?