replace vlook up with match or something

**mmikem** · 03-21-2018, 06:49 PM

Hi all

I have a Vlookup formula that I am using but the problem is if it doesn't find the name its over writing the date on me

Please Login or Register  to view this content.

C27 is persons name sheet 2 it looks for that name on Master Mem List and the writes the date if found on Master Mem List to sheet 2

I need it not to write the date if it did not find a match

any help please

**Mazzaropi** · 03-21-2018, 09:04 PM

mmikem, Good evening.

Try to use:

Please Login or Register  to view this content.

Please, tell us if it worked for you.

I hope it helps.

**mmikem** · 03-22-2018, 10:40 AM

Thanks Mazzaropi

But that did not work

**mmikem** · 03-22-2018, 11:20 AM

I was thinking ( Bad Idea I know )

can I put my look formula in F3 and have the formula return a value to D3 that way I could over write the data in D3 with out erasing the formula

**finalazy** · 03-22-2018, 12:49 PM

Hmm from what I see, you don't need the IF formula

=IFERROR(VLOOKUP(C27,'Master Mem List'!B:C,2,FALSE),"")

should be sufficient..

**mmikem** · 03-22-2018, 02:06 PM

Finalazy Thanks that FORMULA WORKS

But I figured out what is happening If a put the formula in D27 it erases the date I have in that cell I think I need to put the formula in F27 and it write to D27
How would I do that

**finalazy** · 03-22-2018, 02:31 PM

If i understand correctly, just change the target to D27, assuming D27 is the name

=IFERROR(VLOOKUP(D27,'Master Mem List'!B:C,2,FALSE),"")

It would be easier to understand what you want if you can can attach a sample.