Hi experts,
I should be able to crate a spreadsheet and enter a number on a cell and the number entered should look for that same number on another spreadsheeet and bring to me what is on the cell next to it:
I now how to work with vlookup and also with if nut my problem is the following:
I nedd to enter a number between 15001 and 16000 and the cell should go to the next sheet on the same workbook and find in clumn A the cell containing the same number I enter and bring me the info on column B, so far I can use vlookup but I have 2 problems: Problem 1) I can not use excel 2007 so I need to use only the 65536 cels of excel xp so I have a problem because I need to evaluate 100,000 records and problem 2) is that I need to make a formula that says (if the number entered on cell x if found on sheet 2 bring back the data on column b of sheet 2 that belong to record found) I can mange to do
=if(VLOOKUP(A1,Sheet1!A:B,
2,false) this will bring the data found on column b of sheet 2 but I'm limited to only evaluate 65536 records can anybody please help me
Start Free Trial
