IF/Then and V-Lookup

[CS319]

Hello!

I have five sets of data, A-E, and am pulling data via a "v-look up" from Sheet 2 (the data sheet) back to Sheet 1. The data sheet, however, will constantly change; sometimes, it will have data for A-E, other times it will only have data for B-D. I initially told Excel that =IF(VLOOKUP(A1,SHEET2!A1:E9,2,FALSE) > 0, VLOOKUP(A1,SELXX!A1:E9,2,FALSE),0), asking it to pull and post the data point in the box if greater than 0 and if not to simply post 0. Due to the changing nature of the data on SHEET 2 (i.e. sometimes all five characters will have data available, other times just two or three), I sometimes receive an "N/A" message. I presume that's because I'm telling Excel to return a value that doesn't actually "exist" at the moment (but could exist in the future). How do I tell Excel to pull the relevant data point to the first page if the data is greater than 0, but then to post a 0 if it cannot find that data on the second sheet so that I don't get an "N/A" message (can I work around the "N/A" message so that "N/A" becomes synonymous with zero?)

I know this has a few moving parts to it, but I'd be greatly appreciative of any help that anyone can offer.

Thank you in advance!

[MarvinP]

Hi CS319 and welcome to the forum,

I'd suggest you learn about Dynamic Named Ranges. See:
http://www.ozgrid.com/Excel/DynamicRanges.htm