Home |
Search |
Today's Posts |
#4
![]() |
|||
|
|||
![]()
Try adding ,False to the tail of your VLOOKUP formulae (before the closing
bracket) -- HTH Bob Phillips "Brian" wrote in message ... In cell T2 is the bank name...U2 is bank ABA...V2 is bank account (different banks/ account in rows 3, 4 and 5) In cell C12 I have a validation list ($T$2:$T$5) which has four bank names...these four banks are correctly appearing in my dropdown box.... In cell C21 I have the formula =vlookup(c12,T2:V5,2) where I want the bank ABA to appear In cell C22 I have the formula =vlookup(c12,t2:v5,3) where I want the bank account to populate. When I select the first bank name from the drop down list, all the data correctly populates, but when I select the second bank name, the vlookup data still shows the info that relates to the first in the dropdown list. "Bob Phillips" wrote: Show the formula and sample data. -- HTH RP (remove nothere from the email address if mailing direct) "Brian" wrote in message ... I'm trying to use the Vlookup function so that when a particular selection is chosen from a dropdown box, it will then alter data elsewhere in a spreadsheet. I only have 4 items to choose from in my dropdown box.....but the formula is not correctly pulling the Vlookup data I want... For example....item one in the dropdown box is a bank name.....and then I use the vlookup formula to populate a bank account number....but when I choose item two in the dropdown box, my vlookup formula is still pulling the account number for bank one and not bank two. Any ideas why? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
In Cell Validation List & Linked Cell VLOOKUP | Excel Discussion (Misc queries) | |||
Table Array in VLOOKUP Relies on Data Validation | Excel Worksheet Functions | |||
Validation List and VLookup are ackting strange | Excel Worksheet Functions | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |