Software

Ask something
Question Locked

Excel Table Usage

0 helpful
2 replies

by mgdicko

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a complete inventory data set on sheet 1 in excel, i want to be able to call a line from that sheet into a new on ie. type in product code and all details to show (title, price etc)

2 replies

by thumbsup2

After all, that is what it's for.

Just be sure your data is sorted on the column that you'll be using to do the lookup. If it's not, VLookup will return the wrong data.

This discussion is closed to new replies.