Discussion Locked

How to get a pop up box in Excel.

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Anybody know how to link data in two excel file which first excel file have a worksheet for search the part number and show the details of the part number into a pop up box from the second excel file.

Thanks & Rgds,

1 reply

by jimbb

Don't know enough about VBA programming, which I believe you need for the popup, but I can give you the formulas needed for the lookup. Maybe even taht is good enough for you.

First, let's presume you have two sheets:
-partlist.xls: B3-B15 contains part numbers, C3-C15 descriptions, D3-D15 prices.
-lookup.xls: in C5 you fill in a part number, and in C6 it shows the description, in C7 the price.

In partlist.xls you have to do nothing more but fill in the list. It should be sorted on part number, so ideally you put labels in B2, C2, D2, and you use Data | Sort to sort your database properly.

In lookup.xls, in C6, you put the following formula:
=VLOOKUP(C5;[partlist.xls]Sheet1!$B$3:$D$15;2;FALSE)
and in C7:
=VLOOKUP(C5;[partlist.xls]Sheet1!$B$3:$D$15;3;FALSE)

It means, look up the value found in C5 (the partnumber you're looking for). Do so in "Sheet1" of the file "partlist.xls", in the range B3-D15 (your little database). Check column 2 (the descriptions) or 3 (the prices). Return only values if the partnumber is an exact match (= the "FALSE" bit - if you want a "nearest" match you put "TRUE", but I wouldn't do that for looking up partnumbers or zip codes or so)

And that's it. If your partnumber is not correct, it will return #N/A, otherwise it will return what you have put in your database.

Jim

This discussion is closed to new replies.