Hey forum goers,
Im having a problem with my vlookup formula based on two criteria. The information is stored on the data tab and the criteria are in columns A and B. ATM ive concatenated these two criteria in column C and use this as the lookup criteria. No two combinations are the same.
On the blend tab i have validation lists (lists stored on the lists tab), with the second list being depended on what is selected in the first list. I then use the formula:
It works fine except on two combinations Bayswater1-@-12 and Bayswater1-@-14-16. I tried changing the concatenate and renaming the criteria and checking the lists etc but i cannot work out why these will not work.
ive made a copy of the file as i thought it would be simplier to just have a look at it but i cant find the attach file option. And i have uploaded to a site hope you guys dont think its a virus or something. If there is a reputable place i can upload it that you would be comfortable downloading it from, please let me know.
Anyway the link is http://www.mediafire.com/file/zzzmowrircz/Database.xls
and if you have any ideas on how to fix it please let me know.
Im having a problem with my vlookup formula based on two criteria. The information is stored on the data tab and the criteria are in columns A and B. ATM ive concatenated these two criteria in column C and use this as the lookup criteria. No two combinations are the same.
On the blend tab i have validation lists (lists stored on the lists tab), with the second list being depended on what is selected in the first list. I then use the formula:
Code:
=IF(ISNUMBER(MATCH(BLEND!$C3&"-@-"&BLEND!$D3,INDEX(DATA!$C$2:$AR$148,0,1))),VLOOKUP(BLEND!$C3&"-@-"&BLEND!$D3,DATA!$C$2:$AS$148,43,0),0)
It works fine except on two combinations Bayswater1-@-12 and Bayswater1-@-14-16. I tried changing the concatenate and renaming the criteria and checking the lists etc but i cannot work out why these will not work.
ive made a copy of the file as i thought it would be simplier to just have a look at it but i cant find the attach file option. And i have uploaded to a site hope you guys dont think its a virus or something. If there is a reputable place i can upload it that you would be comfortable downloading it from, please let me know.
Anyway the link is http://www.mediafire.com/file/zzzmowrircz/Database.xls
and if you have any ideas on how to fix it please let me know.