EXCEL - Vlookup, match and error probs

[coolcarls]

Hi all! Try again with correcter speeling
I have (for now) 2 issues. !. I get "#N/A" (without the ")so I tried putting the IF(ISNA at the begining but now I have too amny arguments (it tells me). Is there a way to get rid of the #N/A . Here's the formula at question
=INDEX(Sheet1!$A$1:$B$16, MATCH(H23,Sheet1!$A$1:$A$16,), MATCH("Price",Sheet1!$A$1:$B$1,))

Then secondly, I have a list of vendors with names address' phone #'s etc. I have sheet1 as the billing page and don't want to always fill in the address, just choose the vendor name from the list.
I would like sheet1 cell A1 refer to a list of vendors "Vendor Name", when chosen, the other cells below and to the side of Sheet1 A1 fill in the rest of the info. Is this easy/possible.
Thanks for any help!
Carl

 

[SkipVought]

Hi,
[tt]
=If(ISNA(INDEX(Sheet1!$A$1:$B$16, MATCH(H23,Sheet1!$A$1:$A$16,), MATCH("Price",Sheet1!$A$1:$B$1,))),"",INDEX(Sheet1!$A$1:$B$16, MATCH(H23,Sheet1!$A$1:$A$16,), MATCH("Price",Sheet1!$A$1:$B$1,)))
[/tt]
[tt]
=index(TheAddressRange,Match(TheSelectedName,TheNameRange,0),1)
[/tt]


Skip,

_{[red]Be Advised![/red] A man who jumps from a bridge in Paris, is…
INSANE!}