Excel - Lookup and type over? Possible?

h2009 · 15 Apr 2009 at 11:45

Hi there,
I was wondering if anyone could help me.

I've created a lookup table, which returns values to view. But one of the values I need to be able to edit and then return this new value back to the table.

Is there anyway of doing this?

Thanks

Andy100 · 15 Apr 2009 at 22:47

Probably not very helpful but you could just use find and replace on the table sheet.

ctrl & F

dazzerd · 16 Apr 2009 at 12:16

Sounds like you are trying to create a circular formula which wouldnt work i'm afraid.

h2009 · 16 Apr 2009 at 13:23

Ok If anyone wants to help I'll email them a copy of the excel sheet, I've got a lookup working, in a different way this time, but its returning the wrong results, and i can't figure out yet.

Just send me a PM with your email address or post on here, and i'll send the file off to you.
The file does have macros but they dont have to be enabled for it, they just make it easier for uses to input/clear data.

Thanks

A[L]C · 17 Apr 2009 at 09:22

I can have a look for you

paulharman at gmail dot com