firstWeMeet
Board Regular
- Joined
- Feb 8, 2011
- Messages
- 200
Here is my search box.
search box is in sheet1
columnA columnB
A1 = text (description) and B1 = cells with data validation (source from sheet2 description column)
A2 = text (current total qty) and B2 = =IF(B1="","",VLOOKUP(B1,Table1,3,0))
A3 = text (Unit Price) and B3 = ongoing
A4 = text (total stock cost) and B3 = ongoing
here is my problem:
the setup is columnB sheet1 has the formula showing all search data. but as you can see B2 formula, its not working. data source is from sheet2 in a table, anyone can give me the best suggestion and formula?
search box is in sheet1
columnA columnB
A1 = text (description) and B1 = cells with data validation (source from sheet2 description column)
A2 = text (current total qty) and B2 = =IF(B1="","",VLOOKUP(B1,Table1,3,0))
A3 = text (Unit Price) and B3 = ongoing
A4 = text (total stock cost) and B3 = ongoing
here is my problem:
the setup is columnB sheet1 has the formula showing all search data. but as you can see B2 formula, its not working. data source is from sheet2 in a table, anyone can give me the best suggestion and formula?
