Lookup

[Gmata]

Hello, I have to sheets with information

Both have Model Numbers and some more information

I need to match some information using model number, how can i create a
formula to match for example: if in sheet 1 column A is model number and
Sheet 2 Column A i have Model Number Column B Price i need to match the price
to the Model Number in column A

Thanks

 

[James Pranhatkiran]

Hi,

You can use a builtin function in excel called VLOOKUP to perform this.
Step1: Go to the sheet where you want the result to be looked up into.
Step2: click on the empty cell adjacent to a Model number who's details you
want to lookup

Step3: type "=VLOOKUP(A2,Sheet2!A:B,2,0)"
Where:

A2=Cell of "Model No" in Sheet 1 who's data you want to lookup
Sheet2!A:B = Selection of lookup data range .i.e. if you want to lookup the third column information, you need to have Sheet2!A:C.
2 = If you want the result from column 2 .i.e in your case its "price"
0= I am not sure what this is for, but leave it to 0

Try this and let me know if this works!
PS: You will get a better explanation on how VLOOKUP works from the Help
menu

Regards,
James