greetings everyone. i have this worksheet i need to write a S/N number on sheet2 and the information will be taken from sheet1 and pop up in sheet 2. it would be understood through the attachment.
greetings everyone. i have this worksheet i need to write a S/N number on sheet2 and the information will be taken from sheet1 and pop up in sheet 2. it would be understood through the attachment.
Try with VLOOKUP and MATCH.
Quang PT
formula ..
=VLOOKUP($B$2,sheet1!$A$3:$AA$8,ROWS($A$1:A2)
See attached
Last edited by JohnTopley; 11-01-2015 at 01:58 PM.
can u use it in index match cuz later on we will add more people in sheet 1 the one i sent u was till A6 later on itll be more things and i feel index match is more suitable than vlookup cuz later on we dont hve to change the formula in index match.
Why do you have to change the formula: you only enter a new S/N
=VLOOKUP($B$2,sheet1!$A$3:$AA$1000,ROWS($A$1:A2)
will handle 1000 rows in Sheet1. Change 1000 to whatever you need.
Last edited by JohnTopley; 11-02-2015 at 05:54 PM.
i did that but when i change the S/N numbers in the sheet 1, sheet 2 is taking wrong info from sheet 1
Duplicate thread:
https://www.excelforum.com/showthread.php?t=1112247
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks