[ Date Index ]
[ Thread Index ]
[ <= Previous by date /
thread ]
[ Next by date /
thread => ]
Re: [LUG] Spreadsheet help
- To: list@xxxxxxxxxxxxx
- Subject: Re: [LUG] Spreadsheet help
- From: peter walker <peter.walker@xxxxxxxxxxxxxxx>
- Date: Fri, 1 Jul 2022 11:48:29 +0100
- Delivered-to: dclug@xxxxxxxxxxxxxxxxxxxxx
- Dkim-signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=dcglug.org.uk; s=1649667962; h=Sender:Content-Type:Reply-To:List-Subscribe: List-Help:List-Post:List-Unsubscribe:List-Id:Subject:In-Reply-To:From: References:To:MIME-Version:Date:Message-ID:Cc:Content-Transfer-Encoding: Content-ID:Content-Description:Resent-Date:Resent-From:Resent-Sender: Resent-To:Resent-Cc:Resent-Message-ID:List-Owner:List-Archive; bh=GmtojRzaZTtyF0UjwswmjEY761drGGLOsUSYSC0qR/w=; b=rR///sK+QlrHVUHMOBZcAq29hq GjI/Kc3oRTgeiCHKErUbTVLj0OP5tn0KNCE7vRE00oviN2VlYZxMhFtHspY6WRJ18yyzy9MorKA9c k86XJrDDq/uFdQR3xGrVleXcc/C6GOWheSoJbK9bSmEHsCCft2JD75nj2HPN/XfRcgMI=;
Sorry, I should have read more closely. Fairly easy to do it the other
way as well although I ended up concatenating the coords back together
as in your original post.
Something like
=IFERROR(VLOOKUP(CONCAT(B$1,",",$A2),$Sheet1.$A$2:$E$19,5,0),"")
where a new column has been added to the first sheet with the concat coords.
Spreadsheets can turn into a bit of a rabbit hole. Glad the bread turned
out well.
I'll send you a an updated example off list to save on clutter.
Cheers,
Pete
Attachment:
OpenPGP_0xAC005B6AA4B46557.asc
Description: OpenPGP public key
Attachment:
OpenPGP_signature
Description: OpenPGP digital signature
--
The Mailing List for the Devon & Cornwall LUG
https://mailman.dcglug.org.uk/listinfo/list
FAQ: https://www.dcglug.org.uk/faq/