I have the following setup:
Worksheet A:
Contains a Table named tbl_cars
Model || Car Price
=============
Ford || 0
Honda || 0
Toyota || 0
Ferrari || 0
Worksheet B:
Contains three cells:
A1 = Honda
B1 = Car Price
C1 = 15,000
How can I create a macro that uses cells A1 and B1 to look up a proper cell in tbl_cars and then populate it with value in C1?
Hello,
you don't need a macro to do this. You can use Index/Match.
I'm a bit confused, though, as to what you want to look up where. Can you post a real spreadsheet with some sample data and explain what the result should be?
cheers,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks