LinkBack URL
About LinkBacks
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.
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)
Posting Permissions
Register To Reply
Bookmarks